alter table jms_dim.dim_tab_rou_main_city set TBLPROPERTIES('EXTERNAL'='false');
create external table jms_dim.dim_tab_rou_main_city(
province        string comment "省份"       --NVARCHAR2(60)
,province_id     string comment "省份ID"       --NVARCHAR2(20)
,city            string comment "城市"       --NVARCHAR2(60)
,city_id         string comment "省份ID"       --NVARCHAR2(20)
,area            string comment "区县"       --NVARCHAR2(60)
,area_id         string comment "区县ID"       --NVARCHAR2(20)
,create_time     timestamp comment "创建时间"    --   DATE
,modify_time     timestamp comment "最后更新时间"    --   DATE
,create_by       string comment "创建人"       --NVARCHAR2(20)
,create_by_id    string comment "创建人ID"       --NVARCHAR2(20)
,modify_by       string comment "修改人"       --NVARCHAR2(20)
,modify_by_id    string comment "修改人ID"       --NVARCHAR2(20)
,id              string comment "主键ID"       --NVARCHAR2(40)
,is_main      smallint COMMENT '是否主城区1-是，2-否'   --NUMBER(2)
,aging_area_code string comment'时效区县编码'
,aging_area_desc string comment'时效区县'
,aging_city_code string comment'时效城市编码'
,aging_city_desc string comment'时效城市'
,is_enable bigint comment'是否启用:1-是 2-否'
)
comment "主城区维表"
stored as parquet
location "/dw/hive/jms_dim.db/external/dim_tab_rou_main_city";
